 <?php
 require_once '../includes/dbcon.php';

// Check if staff is logged in
if (!isset($_SESSION['staff_id']) || $_SESSION['staff_role'] !== 'teacher') {
    header('Location: staff_login.php');
    exit();
}

$staff_id = $_SESSION['staff_id'];
$message = '';
$message_type = '';

// Fetch staff's assigned classes and subjects
$sql = "SELECT classes, subjects FROM staff WHERE staff_id = :staff_id";
$stmt = $DBcon->prepare($sql);
$stmt->execute([':staff_id' => $staff_id]);
$staff = $stmt->fetch(PDO::FETCH_ASSOC);

$assigned_classes = explode(',', $staff['classes']);
$assigned_subjects = explode(',', $staff['subjects']);

// Get class names
$class_placeholders = str_repeat('?,', count($assigned_classes) - 1) . '?';
$sql_classes = "SELECT sn, classid FROM class WHERE sn IN ($class_placeholders) ORDER BY classid";
$stmt_classes = $DBcon->prepare($sql_classes);
$stmt_classes->execute($assigned_classes);
$classes = $stmt_classes->fetchAll(PDO::FETCH_ASSOC);

// Get subject names
$subject_placeholders = str_repeat('?,', count($assigned_subjects) - 1) . '?';
$sql_subjects = "SELECT subject_id, subjectname FROM subjectss WHERE subject_id IN ($subject_placeholders) ORDER BY subjectname";
$stmt_subjects = $DBcon->prepare($sql_subjects);
$stmt_subjects->execute($assigned_subjects);
$subjects = $stmt_subjects->fetchAll(PDO::FETCH_ASSOC);

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_result'])) {
    $class_id = sanitize_input($_POST['class_id']);
    $subject_id = sanitize_input($_POST['subject_id']);
    $student_name = sanitize_input($_POST['student_name']);
    $student_id = sanitize_input($_POST['student_id']);
    $ca_score = floatval($_POST['ca_score']);
    $exam_score = floatval($_POST['exam_score']);
    $total_score = $ca_score + $exam_score;
    $term = sanitize_input($_POST['term']);
    $session_year = sanitize_input($_POST['session_year']);
    
    // Validate inputs
    if (!in_array($class_id, $assigned_classes)) {
        $message = 'You are not assigned to teach this class';
        $message_type = 'danger';
    } elseif (!in_array($subject_id, $assigned_subjects)) {
        $message = 'You are not assigned to teach this subject';
        $message_type = 'danger';
    } elseif ($ca_score < 0 || $ca_score > 30) {
        $message = 'CA score must be between 0 and 30';
        $message_type = 'danger';
    } elseif ($exam_score < 0 || $exam_score > 70) {
        $message = 'Exam score must be between 0 and 70';
        $message_type = 'danger';
    } else {
        // Check if results table exists, create if not
        $check_table = "CREATE TABLE IF NOT EXISTS student_results (
            result_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
            student_id VARCHAR(50) NOT NULL,
            student_name VARCHAR(100) NOT NULL,
            class_id INT(10) NOT NULL,
            subject_id INT(10) NOT NULL,
            ca_score DECIMAL(5,2) NOT NULL,
            exam_score DECIMAL(5,2) NOT NULL,
            total_score DECIMAL(5,2) NOT NULL,
            term VARCHAR(20) NOT NULL,
            session_year VARCHAR(10) NOT NULL,
            teacher_id INT(10) NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
            PRIMARY KEY (result_id),
            INDEX idx_student (student_id),
            INDEX idx_class (class_id),
            INDEX idx_subject (subject_id),
            INDEX idx_teacher (teacher_id)
        ) ENGINE=InnoDB DEFAULT CHARSET=latin1";
        
        $DBcon->exec($check_table);
        
        // Insert result
        $sql = "INSERT INTO student_results (student_id, student_name, class_id, subject_id, ca_score, exam_score, total_score, term, session_year, teacher_id) 
                VALUES (:student_id, :student_name, :class_id, :subject_id, :ca_score, :exam_score, :total_score, :term, :session_year, :teacher_id)";
        
        $stmt = $DBcon->prepare($sql);
        $result = $stmt->execute([
            ':student_id' => $student_id,
            ':student_name' => $student_name,
            ':class_id' => $class_id,
            ':subject_id' => $subject_id,
            ':ca_score' => $ca_score,
            ':exam_score' => $exam_score,
            ':total_score' => $total_score,
            ':term' => $term,
            ':session_year' => $session_year,
            ':teacher_id' => $staff_id
        ]);
        
        if ($result) {
            $message = 'Result saved successfully!';
            $message_type = 'success';
            
            // Clear form
            $_POST = [];
        } else {
            $message = 'Failed to save result. Please try again.';
            $message_type = 'danger';
        }
    }
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
  <!-- Required meta tags -->
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title>Enter Results - Staff</title>
  <!-- plugins:css -->
  <link rel="stylesheet" href="vendors/iconfonts/font-awesome/css/all.min.css">
  <link rel="stylesheet" href="vendors/css/vendor.bundle.base.css">
  <link rel="stylesheet" href="vendors/css/vendor.bundle.addons.css">
  <!-- endinject -->
  <!-- plugin css for this page -->
  <!-- End plugin css for this page -->
  <!-- inject:css -->
  <link rel="stylesheet" href="css/style.css">
  <!-- endinject -->
  <style>
    .alert {
      padding: 12px 20px;
      border-radius: 5px;
      margin-bottom: 20px;
    }
    .alert-success {
      background-color: #d4edda;
      border-color: #c3e6cb;
      color: #155724;
    }
    .alert-danger {
      background-color: #f8d7da;
      border-color: #f5c6cb;
      color: #721c24;
    }
    .score-input {
      max-width: 150px;
    }
    .form-group {
      margin-bottom: 1.5rem;
    }
  </style>
</head>

<body>
  <div class="container-scroller">
    <?php include("staff_header.php"); ?>
    
    <div class="container-fluid page-body-wrapper">
      <?php include("staff_sidebar.php"); ?>
      
      <div class="main-panel">
        <div class="content-wrapper">
          <div class="page-header">
            <h3 class="page-title">
              <i class="fas fa-edit"></i> Enter Student Results
            </h3>
          </div>
          
          <?php if ($message): ?>
          <div class="alert alert-<?php echo $message_type; ?>">
            <?php echo $message; ?>
          </div>
          <?php endif; ?>
          
          <div class="row">
            <div class="col-md-8 grid-margin stretch-card">
              <div class="card">
                <div class="card-body">
                  <h4 class="card-title">Enter New Result</h4>
                  <p class="card-description">
                    You can only enter results for your assigned classes and subjects.
                  </p>
                  
                  <form method="POST" action="">
                    <div class="row">
                      <div class="col-md-6">
                        <div class="form-group">
                          <label for="class_id">Class *</label>
                          <select class="form-control" id="class_id" name="class_id" required>
                            <option value="">Select Class</option>
                            <?php foreach ($classes as $class): ?>
                            <option value="<?php echo $class['sn']; ?>" 
                                    <?php echo (isset($_POST['class_id']) && $_POST['class_id'] == $class['sn']) ? 'selected' : ''; ?>>
                              <?php echo htmlspecialchars($class['classid']); ?>
                            </option>
                            <?php endforeach; ?>
                          </select>
                        </div>
                      </div>
                      
                      <div class="col-md-6">
                        <div class="form-group">
                          <label for="subject_id">Subject *</label>
                          <select class="form-control" id="subject_id" name="subject_id" required>
                            <option value="">Select Subject</option>
                            <?php foreach ($subjects as $subject): ?>
                            <option value="<?php echo $subject['subject_id']; ?>" 
                                    <?php echo (isset($_POST['subject_id']) && $_POST['subject_id'] == $subject['subject_id']) ? 'selected' : ''; ?>>
                              <?php echo htmlspecialchars($subject['subjectname']); ?>
                            </option>
                            <?php endforeach; ?>
                          </select>
                        </div>
                      </div>
                    </div>
                    
                    <div class="row">
                      <div class="col-md-6">
                        <div class="form-group">
                          <label for="student_id">Student ID *</label>
                          <input type="text" class="form-control" id="student_id" name="student_id" 
                                 value="<?php echo isset($_POST['student_id']) ? htmlspecialchars($_POST['student_id']) : ''; ?>" 
                                 required>
                        </div>
                      </div>
                      
                      <div class="col-md-6">
                        <div class="form-group">
                          <label for="student_name">Student Name *</label>
                          <input type="text" class="form-control" id="student_name" name="student_name" 
                                 value="<?php echo isset($_POST['student_name']) ? htmlspecialchars($_POST['student_name']) : ''; ?>" 
                                 required>
                        </div>
                      </div>
                    </div>
                    
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="ca_score">CA Score (0-30) *</label>
                          <input type="number" class="form-control score-input" id="ca_score" name="ca_score" 
                                 min="0" max="30" step="0.5" 
                                 value="<?php echo isset($_POST['ca_score']) ? htmlspecialchars($_POST['ca_score']) : ''; ?>" 
                                 required>
                        </div>
                      </div>
                      
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="exam_score">Exam Score (0-70) *</label>
                          <input type="number" class="form-control score-input" id="exam_score" name="exam_score" 
                                 min="0" max="70" step="0.5" 
                                 value="<?php echo isset($_POST['exam_score']) ? htmlspecialchars($_POST['exam_score']) : ''; ?>" 
                                 required>
                        </div>
                      </div>
                      
                      <div class="col-md-4">
                        <div class="form-group">
                          <label for="total_score">Total Score</label>
                          <input type="text" class="form-control score-input" id="total_score" 
                                 value="<?php 
                                 if (isset($_POST['ca_score']) && isset($_POST['exam_score'])) {
                                   echo floatval($_POST['ca_score']) + floatval($_POST['exam_score']);
                                 }
                                 ?>" 
                                 readonly>
                        </div>
                      </div>
                    </div>
                    
                    <div class="row">
                      <div class="col-md-6">
                        <div class="form-group">
                          <label for="term">Term *</label>
                          <select class="form-control" id="term" name="term" required>
                            <option value="">Select Term</option>
                            <option value="First Term" <?php echo (isset($_POST['term']) && $_POST['term'] == 'First Term') ? 'selected' : ''; ?>>First Term</option>
                            <option value="Second Term" <?php echo (isset($_POST['term']) && $_POST['term'] == 'Second Term') ? 'selected' : ''; ?>>Second Term</option>
                            <option value="Third Term" <?php echo (isset($_POST['term']) && $_POST['term'] == 'Third Term') ? 'selected' : ''; ?>>Third Term</option>
                          </select>
                        </div>
                      </div>
                      
                      <div class="col-md-6">
                        <div class="form-group">
                          <label for="session_year">Session Year *</label>
                          <select class="form-control" id="session_year" name="session_year" required>
                            <option value="">Select Year</option>
                            <?php 
                            $current_year = date('Y');
                            for ($year = $current_year - 5; $year <= $current_year + 1; $year++): 
                              $session = $year . '/' . ($year + 1);
                            ?>
                            <option value="<?php echo $session; ?>" 
                                    <?php echo (isset($_POST['session_year']) && $_POST['session_year'] == $session) ? 'selected' : ''; ?>>
                              <?php echo $session; ?>
                            </option>
                            <?php endfor; ?>
                          </select>
                        </div>
                      </div>
                    </div>
                    
                    <button type="submit" name="save_result" class="btn btn-primary">
                      <i class="fas fa-save"></i> Save Result
                    </button>
                    <button type="reset" class="btn btn-light">
                      <i class="fas fa-redo"></i> Reset
                    </button>
                  </form>
                </div>
              </div>
            </div>
            
            <div class="col-md-4 grid-margin stretch-card">
              <div class="card">
                <div class="card-body">
                  <h4 class="card-title">
                    <i class="fas fa-info-circle"></i> Grading System
                  </h4>
                  <div class="table-responsive">
                    <table class="table table-striped">
                      <thead>
                        <tr>
                          <th>Score Range</th>
                          <th>Grade</th>
                          <th>Remark</th>
                        </tr>
                      </thead>
                      <tbody>
                        <tr>
                          <td>70 - 100</td>
                          <td>A</td>
                          <td>Excellent</td>
                        </tr>
                        <tr>
                          <td>60 - 69</td>
                          <td>B</td>
                          <td>Very Good</td>
                        </tr>
                        <tr>
                          <td>50 - 59</td>
                          <td>C</td>
                          <td>Good</td>
                        </tr>
                        <tr>
                          <td>45 - 49</td>
                          <td>D</td>
                          <td>Pass</td>
                        </tr>
                        <tr>
                          <td>40 - 44</td>
                          <td>E</td>
                          <td>Fair</td>
                        </tr>
                        <tr>
                          <td>0 - 39</td>
                          <td>F</td>
                          <td>Fail</td>
                        </tr>
                      </tbody>
                    </table>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
        
        <footer class="footer">
          <div class="d-sm-flex justify-content-center justify-content-sm-between">
            <span class="text-muted text-center text-sm-left d-block d-sm-inline-block">Copyright © <?php echo date('Y'); ?> Excellence Academy. All rights reserved.</span>
            <span class="float-none float-sm-right d-block mt-1 mt-sm-0 text-center">You are logged in as: <?php echo htmlspecialchars($_SESSION['staff_name']); ?></span>
          </div>
        </footer>
      </div>
    </div>
  </div>
  
  <!-- plugins:js -->
  <script src="vendors/js/vendor.bundle.base.js"></script>
  <script src="vendors/js/vendor.bundle.addons.js"></script>
  <!-- endinject -->
  <!-- Plugin js for this page-->
  <!-- End plugin js for this page-->
  <!-- inject:js -->
  <script src="js/off-canvas.js"></script>
  <script src="js/hoverable-collapse.js"></script>
  <script src="js/misc.js"></script>
  <script src="js/settings.js"></script>
  <script src="js/todolist.js"></script>
  <!-- endinject -->
  <script>
    // Calculate total score
    document.getElementById('ca_score').addEventListener('input', calculateTotal);
    document.getElementById('exam_score').addEventListener('input', calculateTotal);
    
    function calculateTotal() {
      const caScore = parseFloat(document.getElementById('ca_score').value) || 0;
      const examScore = parseFloat(document.getElementById('exam_score').value) || 0;
      const totalScore = caScore + examScore;
      document.getElementById('total_score').value = totalScore.toFixed(1);
    }
  </script>
</body>
</html>